
<html><HEAD>
<LINK REL=STYLESHEET HREF="default.css" TYPE="text/css">
<TITLE>
Working with validation rules</TITLE>
</HEAD>
<BODY>

<!-- Header -->
<p class="ancestor" align="right"><A HREF="pbugp206.htm">Previous</A>&nbsp;&nbsp;<A HREF="pbugp208.htm" >Next</A>
<!-- End Header -->
<A NAME="X-REF356198657"></A><h1>Working with validation rules</h1>
<A NAME="TI6815"></A><p>You work with validation rules in the Database painter and DataWindow painter.</p>
<A NAME="TI6816"></A><h4>What you do in the Database painter</h4>
<A NAME="TI6817"></A><p>In the Database painter, you can:<A NAME="TI6818"></A>
<ul>
<li class=fi>Create, modify, and delete named validation rules<br>
The validation rules are stored in the extended attribute
system tables. Once you define a validation rule, it can be used
by any column of the appropriate datatype in the database.<br></li>
<li class=ds>Assign validation rules to columns and remove them
from columns<br>
These rules are used by default when you place the column
in a DataWindow object in the DataWindow painter.<br>
</li>
</ul>
</p>
<A NAME="TI6819"></A><h4>What you do in the DataWindow painter</h4>
<A NAME="TI6820"></A><p>In the DataWindow painter, you can:<A NAME="TI6821"></A>
<ul>
<li class=fi>Accept the default validation rule assigned to a column in
the Database painter</li>
<li class=ds>Create an ad hoc, unnamed rule to use with one specific
column
</li>
</ul>
</p>
<A NAME="TI6822"></A><h4>Validation rules and the extended attribute system
tables</h4>
<A NAME="TI6823"></A><p>Once you have placed a column that has a validation rule from
the extended attribute system tables in a DataWindow object, there is no
longer any link to the named rule in the extended attribute system
tables.</p>
<A NAME="TI6824"></A><p>If the definition of the validation rule later changes in
the extended attribute system tables, the rule for the column in
a DataWindow object will not change.</p>

